﻿<?xml version="1.0" encoding="utf-8" ?>
<DbDataRequest connection="$UserLoginDBConnection$" type="$UserLoginDbType$" defaultFormatter="bizobj User">
  <SqlStatement hasResults="true">
    SELECT     
        u.id, 
        u.userName, 
        u.password,
        c.id as companyId
    FROM
      Users u
    INNER JOIN
      Companies c ON u.companyId = c.id 
    WHERE c.id=@id
  </SqlStatement>
  <Param name="id" type="UniqueIdentifier"/>
 </DbDataRequest>